<?php

session_start();

include_once("conf/config.inc.php");
include_once(DATEIPFAD . "conf/db.inc.php");
include_once(DATEIPFAD . "includes/functions.language.inc.php");
include_once(DATEIPFAD . "includes/functions.kategorie.inc.php");
include_once(DATEIPFAD . "includes/functions.seo.inc.php");

// URL Einlesen
if ($_SERVER["QUERY_STRING"]) {
    $URLParamaterString = trim(substr(substr($_SERVER['REQUEST_URI'], 0, strlen($_SERVER['REQUEST_URI']) - (strlen($_SERVER["QUERY_STRING"]) + 1)), strlen($_SERVER['SCRIPT_NAME']) - strlen(CONTROLLER_FILE)));
} else {
    $URLParamaterString = trim(substr($_SERVER['REQUEST_URI'], strlen($_SERVER['SCRIPT_NAME']) - strlen(CONTROLLER_FILE)));
}

// Startseite anzeigen
if ($URLParamaterString == '') {

    $SEOCall = true;
    include_once(DATEIPFAD . "index.php");
    exit;
    
}

//echo '<pre>';
//var_dump($URLParamaterString);
//echo '</pre>';

$SQLString = 'SELECT ';
$SQLString .= TABLE_SEOURLS . '.kategorie_id, ';
$SQLString .= TABLE_SEOURLS . '.hersteller_id, ';
$SQLString .= TABLE_SEOURLS . '.aktions_id, ';
$SQLString .= TABLE_SEOURLS . '.menue_id, ';
$SQLString .= TABLE_SEOURLS . '.artikel_id, ';
$SQLString .= TABLE_SEOURLS . '.type, ';
$SQLString .= TABLE_SEOURLS . '.http_status,  ';
$SQLString .= TABLE_SEOURLS . '.redirect_seourl_id ';
$SQLString .= 'FROM ';
$SQLString .= TABLE_SEOURLS . ' ';
$SQLString .= 'WHERE ';
$SQLString .= TABLE_SEOURLS . '.url = \'' . $URLParamaterString . '\' ';

$SEOURLObject = mysql_fetch_object(errorlogged_mysql_query($SQLString));

if ($SEOURLObject) {
    
    // Umleitung
    if ($SEOURLObject->http_status == 301) {
        
        if ($SEOURLObject->redirect_seourl_id == 0) {
            
            $RedirectURL = URLPFAD;
            
        } else {
            
            $SQLString = 'SELECT ';
            $SQLString .= TABLE_SEOURLS . '.url ';
            $SQLString .= 'FROM ';
            $SQLString .= TABLE_SEOURLS . ' ';
            $SQLString .= 'WHERE ';
            $SQLString .= TABLE_SEOURLS . '.seourl_id = \'' . $SEOURLObject->redirect_seourl_id . '\' ';
            
            $RedirectSEOURLObject = mysql_fetch_object(errorlogged_mysql_query($SQLString));
        
            $RedirectURL = URLPFAD . $RedirectSEOURLObject->url;
        
        }
        
        header('Location: ' . $RedirectURL, true, 301);
        exit;
                
    }
    
    if ($SEOURLObject->type == SEOURL_TYPE_CMS_KATEGORIE) {
    
        $_REQUEST['kategorieid'] = $SEOURLObject->kategorie_id;
        $_GET["kategorieid"] = $SEOURLObject->kategorie_id;
        $SEOCall = true;
        include_once(DATEIPFAD . "includes/functions.global.inc.php");
        include_once(DATEIPFAD . "cms/kategorie/index.php");
        exit;
    
    } elseif ($SEOURLObject->type == SEOURL_TYPE_MENUE) {
    
        $_GET['id'] = $SEOURLObject->menue_id;
        $SEOCall = true;
        include_once(DATEIPFAD . "includes/functions.global.inc.php");
        include_once(DATEIPFAD . "themes/topnavi/index.php");
        exit;
    
    } elseif ($SEOURLObject->type == SEOURL_TYPE_AKTION) {
    
        $_GET['aktionsid'] = $SEOURLObject->aktions_id;
        $SEOCall = true;
        include_once(DATEIPFAD . "includes/functions.global.inc.php");
        include_once(DATEIPFAD . "themes/kategorie/aktion.php");
        exit;
    
    } elseif ($SEOURLObject->type == SEOURL_TYPE_HERSTELLER) {
    
        $_GET['herstellerid'] = $SEOURLObject->hersteller_id;
        $SEOCall = true;
        include_once(DATEIPFAD . "includes/functions.global.inc.php");
        include_once(DATEIPFAD . "themes/kategorie/hersteller.php");
        exit;
    
    } elseif ($SEOURLObject->type == SEOURL_TYPE_KATEGORIE) {
    
        $_REQUEST['kategorieid'] = $SEOURLObject->kategorie_id;
        $_GET["kategorieid"] = $SEOURLObject->kategorie_id;
        $SEOCall = true;
        include_once(DATEIPFAD . "includes/functions.global.inc.php");
        include_once(DATEIPFAD . "themes/kategorie/index.php");
        exit;
        
    } elseif ($SEOURLObject->type == SEOURL_TYPE_ARTIKEL) {
        
        $_REQUEST['artikelid'] = $SEOURLObject->artikel_id;
        $_GET["artikelid"] = $SEOURLObject->artikel_id;
        $_REQUEST['kategorieid'] = $SEOURLObject->kategorie_id;
        $_GET["kategorieid"] = $SEOURLObject->kategorie_id;
        $SEOCall = true;
        include_once(DATEIPFAD . "themes/kategorie/detail.php");
        exit;
    
    } else {
	    header('Location: ' . URLPFAD . 'themes/error/error_404.php');
	    exit;
    
    }
    
} else {
    header('Location: ' . URLPFAD . 'themes/error/error_404.php');
    exit;
    
}
